Value Field Settings

You can choose the type of calculation you wish to use to summarize and display the data in the PivotTable and PivotChart.

 

7. Try it: Edit the Value Field Settings

Go to the Summary list.

Choose: Sum.

 

What Do You See? The Custom Name should be Sum of Amount, now.

 

Please click OK and keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Edit the Value Field Settings

PivotChart Tools ->Analyze ->Show/Hide->Field List